
/* change the directory to where the nlsfw1icp.sas7bdat is located */
libname library 'c:\' ;

proc format library = library ;
   value DOC010A /* us news doctoral ranking 01-02 */
      200 = 'second tier'  
      300 = 'third tier'  
      999 = 'not applicable ' ;
   value MAST010A /* us news masters ranking 98-99 */
      200 = 'second tier'  
      300 = 'third tier'  
      999 = 'not applicable or not available' ;
   value LA010A /* us news liberal arts ranking 01-02 */
      200 = 'second tier'  
      300 = 'third tier'  
      999 = 'not applicable or not available' ;
   value FRAT010A /* % in fraternities 01-02 */
      999 = 'not applicable or not available' ;
   value SORO010A /* % in sororities 01-02 */
      999 = 'not applicable or not available' ;
   value INTU010A /* tuition/fees in state  01-02 */
      999 = 'not applicable or not available' ;
   value APP010A /* % of undergrads that applied for aid 01-02 */
      888 = 'declined to respond' ;
   value NEED010A /* % of undergrads determined to have need 01-02 */
      888 = 'declined to respond' ;
   value AID010A /* % of undergrads with need met 01-02 */
      888 = 'declined to respond' ;
   value PACK010A /* avg annual aid package 01-02 */
      888 = 'declined to respond' ;
   value GRNT010A /* % receiving grants 01-02 */
      888 = 'declined to respond' ;
   value AMT010A /* avg annual grant amt 01-02 */
      888 = 'declined to respond' ;
   value DEBT010A /* % of grads with debt 01-02 */
      888 = 'declined to respond' ;
   value INDE010A /* avg amount of debt 01-02 */
      888 = 'declined to respond' ;
   value DOC989A /* us news doctoral ranking 98-99 */
      200 = 'second tier'  
      300 = 'third tier'  
      999 = 'not applicable' ;
   value REG989A /* us news regional ranking 98-99 */
      100 = 'top tier'  
      200 = 'second tier'  
      300 = 'third tier'  
      999 = 'not applicable' ;
   value LA989A /* us news liberal arts ranking 98-99 */
      200 = 'second tier'  
      300 = 'third tier'  
      400 = 'fourth tier'  
      999 = 'not applicable' ;
   value WHIT989A /* % white 98-99 */
      999 = 'not applicable or not available' ;
   value BLAC989A /* % black 98-99 */
      999 = 'not applicable or not available' ;
   value HISP989A /* % hispanic 98-99 */
      999 = 'not applicable or not available' ;
   value ASIA989A /* % asia 98-99 */
      999 = 'not applicable or not available' ;
   value INST989A /* % from in state 98-99 */
      888 = 'declined to respond'  
      999 = 'not applicable or not available' ;
   value CAMP989A /* % living on campus 98-99 */
      888 = 'declined to respond'  
      999 = 'not applicable or not available' ;
   value FRAT989A /* % in fraternities 98-99 */
      999 = 'not applicable or not available' ;
   value SORO989A /* % in sororities 98-99 */
      999 = 'not applicable or not available' ;
   value INTU989A /* tuition/fees in state 98-99 */
      999 = 'not applicable' ;
   value ROOM989A /* room/board 98-99 */
      999 = 'not applicable or not available' ;
   value APP989A /* % of undergrads that applied for aid 98-99 */
      888 = 'declined to respond'  
      999 = 'not applicable or not available' ;
   value NEED989A /* % of undergrads determined to have need */
      888 = 'declined to respond'  
      999 = 'not applicable or not available' ;
   value AID989A /* % of undergrads with need met 98-99 */
      888 = 'declined to respond'  
      999 = 'not applicable or not available' ;
   value PACK989A /* avg annual aid package 98-99 */
      888 = 'declined to respond'  
      999 = 'not applicable or not available' ;
   value GRNT989A /* % receiving grants 98-99 */
      888 = 'declined to respond'  
      999 = 'not applicable or not available' ;
   value AMT989A /* avg annual grant amt 98-99 */
      888 = 'declined to respond'  
      999 = 'not applicable or not available' ;
   value DEBT989A /* % of grads with debt 98-99 */
      888 = 'declined to respond'  
      999 = 'not applicable or not available' ;
   value INDE989A /* avg amount of debt 98-99 */
      888 = 'declined to respond'  
      999 = 'not applicable or not available' ;

proc datasets library = library ;
modify nlsfw1icp;
   format   DOC0102 DOC010A.;
   format  MAST0102 MAST010A.;
   format    LA0102 LA010A.;
   format  FRAT0102 FRAT010A.;
   format  SORO0102 SORO010A.;
   format  INTU0102 INTU010A.;
   format   APP0102 APP010A.;
   format  NEED0102 NEED010A.;
   format   AID0102 AID010A.;
   format  PACK0102 PACK010A.;
   format  GRNT0102 GRNT010A.;
   format   AMT0102 AMT010A.;
   format  DEBT0102 DEBT010A.;
   format  INDE0102 INDE010A.;
   format   DOC9899 DOC989A.;
   format   REG9899 REG989A.;
   format    LA9899 LA989A.;
   format  WHIT9899 WHIT989A.;
   format  BLAC9899 BLAC989A.;
   format  HISP9899 HISP989A.;
   format  ASIA9899 ASIA989A.;
   format  INST9899 INST989A.;
   format  CAMP9899 CAMP989A.;
   format  FRAT9899 FRAT989A.;
   format  SORO9899 SORO989A.;
   format  INTU9899 INTU989A.;
   format  ROOM9899 ROOM989A.;
   format   APP9899 APP989A.;
   format  NEED9899 NEED989A.;
   format   AID9899 AID989A.;
   format  PACK9899 PACK989A.;
   format  GRNT9899 GRNT989A.;
   format   AMT9899 AMT989A.;
   format  DEBT9899 DEBT989A.;
   format  INDE9899 INDE989A.;
quit;
